
import openpyxl

def read_excel(file_name):
    workbook = openpyxl.load_workbook(file_name)
    sheet_name = workbook['Sheet1']
    data = []
    for row in sheet_name.iter_rows(min_row=2,values_only=True):
        account = row[1]
        password = row[2]
        assertion = row[3]
        data.append((account,password,assertion))
    return data


if __name__ == '__main__':
    print(read_excel('../data/登陆账号.xlsx'))
